package com.warm.pump.module.work.bean.po.gen;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class WorkItemSubExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected int limitStart = -1;

    protected int limitOffset = -1;

    public WorkItemSubExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setLimitStart(int limitStart) {
        this.limitStart=limitStart;
    }

    public int getLimitStart() {
        return limitStart;
    }

    public void setLimitOffset(int limitOffset) {
        this.limitOffset=limitOffset;
    }

    public int getLimitOffset() {
        return limitOffset;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }



        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("id =", value, "Id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("id <>", value, "Id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("id >", value, "Id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("id >=", value, "Id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("id <", value, "Id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("id <=", value, "Id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("id in", values, "Id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("id not in", values, "Id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("id between", value1, value2, "Id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("id not between", value1, value2, "Id");
            return (Criteria) this;
        }
        public Criteria andItemIdIsNull() {
            addCriterion("item_id is null");
            return (Criteria) this;
        }

        public Criteria andItemIdIsNotNull() {
            addCriterion("item_id is not null");
            return (Criteria) this;
        }

        public Criteria andItemIdEqualTo(Long value) {
            addCriterion("item_id =", value, "ItemId");
            return (Criteria) this;
        }

        public Criteria andItemIdNotEqualTo(Long value) {
            addCriterion("item_id <>", value, "ItemId");
            return (Criteria) this;
        }

        public Criteria andItemIdGreaterThan(Long value) {
            addCriterion("item_id >", value, "ItemId");
            return (Criteria) this;
        }

        public Criteria andItemIdGreaterThanOrEqualTo(Long value) {
            addCriterion("item_id >=", value, "ItemId");
            return (Criteria) this;
        }

        public Criteria andItemIdLessThan(Long value) {
            addCriterion("item_id <", value, "ItemId");
            return (Criteria) this;
        }

        public Criteria andItemIdLessThanOrEqualTo(Long value) {
            addCriterion("item_id <=", value, "ItemId");
            return (Criteria) this;
        }

        public Criteria andItemIdIn(List<Long> values) {
            addCriterion("item_id in", values, "ItemId");
            return (Criteria) this;
        }

        public Criteria andItemIdNotIn(List<Long> values) {
            addCriterion("item_id not in", values, "ItemId");
            return (Criteria) this;
        }

        public Criteria andItemIdBetween(Long value1, Long value2) {
            addCriterion("item_id between", value1, value2, "ItemId");
            return (Criteria) this;
        }

        public Criteria andItemIdNotBetween(Long value1, Long value2) {
            addCriterion("item_id not between", value1, value2, "ItemId");
            return (Criteria) this;
        }
        public Criteria andSubNameIsNull() {
            addCriterion("sub_name is null");
            return (Criteria) this;
        }

        public Criteria andSubNameIsNotNull() {
            addCriterion("sub_name is not null");
            return (Criteria) this;
        }

        public Criteria andSubNameEqualTo(String value) {
            addCriterion("sub_name =", value, "SubName");
            return (Criteria) this;
        }

        public Criteria andSubNameNotEqualTo(String value) {
            addCriterion("sub_name <>", value, "SubName");
            return (Criteria) this;
        }

        public Criteria andSubNameGreaterThan(String value) {
            addCriterion("sub_name >", value, "SubName");
            return (Criteria) this;
        }

        public Criteria andSubNameGreaterThanOrEqualTo(String value) {
            addCriterion("sub_name >=", value, "SubName");
            return (Criteria) this;
        }

        public Criteria andSubNameLessThan(String value) {
            addCriterion("sub_name <", value, "SubName");
            return (Criteria) this;
        }

        public Criteria andSubNameLessThanOrEqualTo(String value) {
            addCriterion("sub_name <=", value, "SubName");
            return (Criteria) this;
        }

        public Criteria andSubNameLike(String value) {
            addCriterion("sub_name like", value, "SubName");
            return (Criteria) this;
        }

        public Criteria andSubNameNotLike(String value) {
            addCriterion("sub_name not like", value, "SubName");
            return (Criteria) this;
        }

        public Criteria andSubNameIn(List<String> values) {
            addCriterion("sub_name in", values, "SubName");
            return (Criteria) this;
        }

        public Criteria andSubNameNotIn(List<String> values) {
            addCriterion("sub_name not in", values, "SubName");
            return (Criteria) this;
        }

        public Criteria andSubNameBetween(String value1, String value2) {
            addCriterion("sub_name between", value1, value2, "SubName");
            return (Criteria) this;
        }

        public Criteria andSubNameNotBetween(String value1, String value2) {
            addCriterion("sub_name not between", value1, value2, "SubName");
            return (Criteria) this;
        }
        public Criteria andDbKeyFromIsNull() {
            addCriterion("db_key_from is null");
            return (Criteria) this;
        }

        public Criteria andDbKeyFromIsNotNull() {
            addCriterion("db_key_from is not null");
            return (Criteria) this;
        }

        public Criteria andDbKeyFromEqualTo(String value) {
            addCriterion("db_key_from =", value, "DbKeyFrom");
            return (Criteria) this;
        }

        public Criteria andDbKeyFromNotEqualTo(String value) {
            addCriterion("db_key_from <>", value, "DbKeyFrom");
            return (Criteria) this;
        }

        public Criteria andDbKeyFromGreaterThan(String value) {
            addCriterion("db_key_from >", value, "DbKeyFrom");
            return (Criteria) this;
        }

        public Criteria andDbKeyFromGreaterThanOrEqualTo(String value) {
            addCriterion("db_key_from >=", value, "DbKeyFrom");
            return (Criteria) this;
        }

        public Criteria andDbKeyFromLessThan(String value) {
            addCriterion("db_key_from <", value, "DbKeyFrom");
            return (Criteria) this;
        }

        public Criteria andDbKeyFromLessThanOrEqualTo(String value) {
            addCriterion("db_key_from <=", value, "DbKeyFrom");
            return (Criteria) this;
        }

        public Criteria andDbKeyFromLike(String value) {
            addCriterion("db_key_from like", value, "DbKeyFrom");
            return (Criteria) this;
        }

        public Criteria andDbKeyFromNotLike(String value) {
            addCriterion("db_key_from not like", value, "DbKeyFrom");
            return (Criteria) this;
        }

        public Criteria andDbKeyFromIn(List<String> values) {
            addCriterion("db_key_from in", values, "DbKeyFrom");
            return (Criteria) this;
        }

        public Criteria andDbKeyFromNotIn(List<String> values) {
            addCriterion("db_key_from not in", values, "DbKeyFrom");
            return (Criteria) this;
        }

        public Criteria andDbKeyFromBetween(String value1, String value2) {
            addCriterion("db_key_from between", value1, value2, "DbKeyFrom");
            return (Criteria) this;
        }

        public Criteria andDbKeyFromNotBetween(String value1, String value2) {
            addCriterion("db_key_from not between", value1, value2, "DbKeyFrom");
            return (Criteria) this;
        }
        public Criteria andSubSqlIsNull() {
            addCriterion("sub_sql is null");
            return (Criteria) this;
        }

        public Criteria andSubSqlIsNotNull() {
            addCriterion("sub_sql is not null");
            return (Criteria) this;
        }

        public Criteria andSubSqlEqualTo(String value) {
            addCriterion("sub_sql =", value, "SubSql");
            return (Criteria) this;
        }

        public Criteria andSubSqlNotEqualTo(String value) {
            addCriterion("sub_sql <>", value, "SubSql");
            return (Criteria) this;
        }

        public Criteria andSubSqlGreaterThan(String value) {
            addCriterion("sub_sql >", value, "SubSql");
            return (Criteria) this;
        }

        public Criteria andSubSqlGreaterThanOrEqualTo(String value) {
            addCriterion("sub_sql >=", value, "SubSql");
            return (Criteria) this;
        }

        public Criteria andSubSqlLessThan(String value) {
            addCriterion("sub_sql <", value, "SubSql");
            return (Criteria) this;
        }

        public Criteria andSubSqlLessThanOrEqualTo(String value) {
            addCriterion("sub_sql <=", value, "SubSql");
            return (Criteria) this;
        }

        public Criteria andSubSqlLike(String value) {
            addCriterion("sub_sql like", value, "SubSql");
            return (Criteria) this;
        }

        public Criteria andSubSqlNotLike(String value) {
            addCriterion("sub_sql not like", value, "SubSql");
            return (Criteria) this;
        }

        public Criteria andSubSqlIn(List<String> values) {
            addCriterion("sub_sql in", values, "SubSql");
            return (Criteria) this;
        }

        public Criteria andSubSqlNotIn(List<String> values) {
            addCriterion("sub_sql not in", values, "SubSql");
            return (Criteria) this;
        }

        public Criteria andSubSqlBetween(String value1, String value2) {
            addCriterion("sub_sql between", value1, value2, "SubSql");
            return (Criteria) this;
        }

        public Criteria andSubSqlNotBetween(String value1, String value2) {
            addCriterion("sub_sql not between", value1, value2, "SubSql");
            return (Criteria) this;
        }
        public Criteria andOrderNumIsNull() {
            addCriterion("order_num is null");
            return (Criteria) this;
        }

        public Criteria andOrderNumIsNotNull() {
            addCriterion("order_num is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNumEqualTo(Integer value) {
            addCriterion("order_num =", value, "OrderNum");
            return (Criteria) this;
        }

        public Criteria andOrderNumNotEqualTo(Integer value) {
            addCriterion("order_num <>", value, "OrderNum");
            return (Criteria) this;
        }

        public Criteria andOrderNumGreaterThan(Integer value) {
            addCriterion("order_num >", value, "OrderNum");
            return (Criteria) this;
        }

        public Criteria andOrderNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("order_num >=", value, "OrderNum");
            return (Criteria) this;
        }

        public Criteria andOrderNumLessThan(Integer value) {
            addCriterion("order_num <", value, "OrderNum");
            return (Criteria) this;
        }

        public Criteria andOrderNumLessThanOrEqualTo(Integer value) {
            addCriterion("order_num <=", value, "OrderNum");
            return (Criteria) this;
        }

        public Criteria andOrderNumIn(List<Integer> values) {
            addCriterion("order_num in", values, "OrderNum");
            return (Criteria) this;
        }

        public Criteria andOrderNumNotIn(List<Integer> values) {
            addCriterion("order_num not in", values, "OrderNum");
            return (Criteria) this;
        }

        public Criteria andOrderNumBetween(Integer value1, Integer value2) {
            addCriterion("order_num between", value1, value2, "OrderNum");
            return (Criteria) this;
        }

        public Criteria andOrderNumNotBetween(Integer value1, Integer value2) {
            addCriterion("order_num not between", value1, value2, "OrderNum");
            return (Criteria) this;
        }
        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "CreateTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "CreateTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "CreateTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "CreateTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "CreateTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "CreateTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "CreateTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "CreateTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "CreateTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "CreateTime");
            return (Criteria) this;
        }
        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "UpdateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "UpdateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "UpdateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "UpdateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "UpdateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "UpdateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "UpdateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "UpdateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "UpdateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "UpdateTime");
            return (Criteria) this;
        }
        public Criteria andSubTypeIsNull() {
            addCriterion("sub_type is null");
            return (Criteria) this;
        }

        public Criteria andSubTypeIsNotNull() {
            addCriterion("sub_type is not null");
            return (Criteria) this;
        }

        public Criteria andSubTypeEqualTo(String value) {
            addCriterion("sub_type =", value, "SubType");
            return (Criteria) this;
        }

        public Criteria andSubTypeNotEqualTo(String value) {
            addCriterion("sub_type <>", value, "SubType");
            return (Criteria) this;
        }

        public Criteria andSubTypeGreaterThan(String value) {
            addCriterion("sub_type >", value, "SubType");
            return (Criteria) this;
        }

        public Criteria andSubTypeGreaterThanOrEqualTo(String value) {
            addCriterion("sub_type >=", value, "SubType");
            return (Criteria) this;
        }

        public Criteria andSubTypeLessThan(String value) {
            addCriterion("sub_type <", value, "SubType");
            return (Criteria) this;
        }

        public Criteria andSubTypeLessThanOrEqualTo(String value) {
            addCriterion("sub_type <=", value, "SubType");
            return (Criteria) this;
        }

        public Criteria andSubTypeLike(String value) {
            addCriterion("sub_type like", value, "SubType");
            return (Criteria) this;
        }

        public Criteria andSubTypeNotLike(String value) {
            addCriterion("sub_type not like", value, "SubType");
            return (Criteria) this;
        }

        public Criteria andSubTypeIn(List<String> values) {
            addCriterion("sub_type in", values, "SubType");
            return (Criteria) this;
        }

        public Criteria andSubTypeNotIn(List<String> values) {
            addCriterion("sub_type not in", values, "SubType");
            return (Criteria) this;
        }

        public Criteria andSubTypeBetween(String value1, String value2) {
            addCriterion("sub_type between", value1, value2, "SubType");
            return (Criteria) this;
        }

        public Criteria andSubTypeNotBetween(String value1, String value2) {
            addCriterion("sub_type not between", value1, value2, "SubType");
            return (Criteria) this;
        }
        public Criteria andCacheNameIsNull() {
            addCriterion("cache_name is null");
            return (Criteria) this;
        }

        public Criteria andCacheNameIsNotNull() {
            addCriterion("cache_name is not null");
            return (Criteria) this;
        }

        public Criteria andCacheNameEqualTo(String value) {
            addCriterion("cache_name =", value, "CacheName");
            return (Criteria) this;
        }

        public Criteria andCacheNameNotEqualTo(String value) {
            addCriterion("cache_name <>", value, "CacheName");
            return (Criteria) this;
        }

        public Criteria andCacheNameGreaterThan(String value) {
            addCriterion("cache_name >", value, "CacheName");
            return (Criteria) this;
        }

        public Criteria andCacheNameGreaterThanOrEqualTo(String value) {
            addCriterion("cache_name >=", value, "CacheName");
            return (Criteria) this;
        }

        public Criteria andCacheNameLessThan(String value) {
            addCriterion("cache_name <", value, "CacheName");
            return (Criteria) this;
        }

        public Criteria andCacheNameLessThanOrEqualTo(String value) {
            addCriterion("cache_name <=", value, "CacheName");
            return (Criteria) this;
        }

        public Criteria andCacheNameLike(String value) {
            addCriterion("cache_name like", value, "CacheName");
            return (Criteria) this;
        }

        public Criteria andCacheNameNotLike(String value) {
            addCriterion("cache_name not like", value, "CacheName");
            return (Criteria) this;
        }

        public Criteria andCacheNameIn(List<String> values) {
            addCriterion("cache_name in", values, "CacheName");
            return (Criteria) this;
        }

        public Criteria andCacheNameNotIn(List<String> values) {
            addCriterion("cache_name not in", values, "CacheName");
            return (Criteria) this;
        }

        public Criteria andCacheNameBetween(String value1, String value2) {
            addCriterion("cache_name between", value1, value2, "CacheName");
            return (Criteria) this;
        }

        public Criteria andCacheNameNotBetween(String value1, String value2) {
            addCriterion("cache_name not between", value1, value2, "CacheName");
            return (Criteria) this;
        }
        public Criteria andCacheKeyFieldIsNull() {
            addCriterion("cache_key_field is null");
            return (Criteria) this;
        }

        public Criteria andCacheKeyFieldIsNotNull() {
            addCriterion("cache_key_field is not null");
            return (Criteria) this;
        }

        public Criteria andCacheKeyFieldEqualTo(String value) {
            addCriterion("cache_key_field =", value, "CacheKeyField");
            return (Criteria) this;
        }

        public Criteria andCacheKeyFieldNotEqualTo(String value) {
            addCriterion("cache_key_field <>", value, "CacheKeyField");
            return (Criteria) this;
        }

        public Criteria andCacheKeyFieldGreaterThan(String value) {
            addCriterion("cache_key_field >", value, "CacheKeyField");
            return (Criteria) this;
        }

        public Criteria andCacheKeyFieldGreaterThanOrEqualTo(String value) {
            addCriterion("cache_key_field >=", value, "CacheKeyField");
            return (Criteria) this;
        }

        public Criteria andCacheKeyFieldLessThan(String value) {
            addCriterion("cache_key_field <", value, "CacheKeyField");
            return (Criteria) this;
        }

        public Criteria andCacheKeyFieldLessThanOrEqualTo(String value) {
            addCriterion("cache_key_field <=", value, "CacheKeyField");
            return (Criteria) this;
        }

        public Criteria andCacheKeyFieldLike(String value) {
            addCriterion("cache_key_field like", value, "CacheKeyField");
            return (Criteria) this;
        }

        public Criteria andCacheKeyFieldNotLike(String value) {
            addCriterion("cache_key_field not like", value, "CacheKeyField");
            return (Criteria) this;
        }

        public Criteria andCacheKeyFieldIn(List<String> values) {
            addCriterion("cache_key_field in", values, "CacheKeyField");
            return (Criteria) this;
        }

        public Criteria andCacheKeyFieldNotIn(List<String> values) {
            addCriterion("cache_key_field not in", values, "CacheKeyField");
            return (Criteria) this;
        }

        public Criteria andCacheKeyFieldBetween(String value1, String value2) {
            addCriterion("cache_key_field between", value1, value2, "CacheKeyField");
            return (Criteria) this;
        }

        public Criteria andCacheKeyFieldNotBetween(String value1, String value2) {
            addCriterion("cache_key_field not between", value1, value2, "CacheKeyField");
            return (Criteria) this;
        }
        public Criteria andCacheGetFieldsIsNull() {
            addCriterion("cache_get_fields is null");
            return (Criteria) this;
        }

        public Criteria andCacheGetFieldsIsNotNull() {
            addCriterion("cache_get_fields is not null");
            return (Criteria) this;
        }

        public Criteria andCacheGetFieldsEqualTo(String value) {
            addCriterion("cache_get_fields =", value, "CacheGetFields");
            return (Criteria) this;
        }

        public Criteria andCacheGetFieldsNotEqualTo(String value) {
            addCriterion("cache_get_fields <>", value, "CacheGetFields");
            return (Criteria) this;
        }

        public Criteria andCacheGetFieldsGreaterThan(String value) {
            addCriterion("cache_get_fields >", value, "CacheGetFields");
            return (Criteria) this;
        }

        public Criteria andCacheGetFieldsGreaterThanOrEqualTo(String value) {
            addCriterion("cache_get_fields >=", value, "CacheGetFields");
            return (Criteria) this;
        }

        public Criteria andCacheGetFieldsLessThan(String value) {
            addCriterion("cache_get_fields <", value, "CacheGetFields");
            return (Criteria) this;
        }

        public Criteria andCacheGetFieldsLessThanOrEqualTo(String value) {
            addCriterion("cache_get_fields <=", value, "CacheGetFields");
            return (Criteria) this;
        }

        public Criteria andCacheGetFieldsLike(String value) {
            addCriterion("cache_get_fields like", value, "CacheGetFields");
            return (Criteria) this;
        }

        public Criteria andCacheGetFieldsNotLike(String value) {
            addCriterion("cache_get_fields not like", value, "CacheGetFields");
            return (Criteria) this;
        }

        public Criteria andCacheGetFieldsIn(List<String> values) {
            addCriterion("cache_get_fields in", values, "CacheGetFields");
            return (Criteria) this;
        }

        public Criteria andCacheGetFieldsNotIn(List<String> values) {
            addCriterion("cache_get_fields not in", values, "CacheGetFields");
            return (Criteria) this;
        }

        public Criteria andCacheGetFieldsBetween(String value1, String value2) {
            addCriterion("cache_get_fields between", value1, value2, "CacheGetFields");
            return (Criteria) this;
        }

        public Criteria andCacheGetFieldsNotBetween(String value1, String value2) {
            addCriterion("cache_get_fields not between", value1, value2, "CacheGetFields");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}
